var cid = '' var cGroupname = "" var nStatusCode = 0 var lContinue = true var groupname = request.groupname cursor1 = database.cursor("select * from settings") cursor1.next() cCurrweek = cursor1.viewweek cCurryear = cursor1.viewyear cursor1.close() cursor1 = database.cursor("select * from groupm where groupname = '" + request.groupname + "'") cursor1.next() commissioner = ( alltrim(cursor1.commissioner) ? cursor1.commissioner : " " ) description = ( alltrim(cursor1.description) ? cursor1.description : " " ) comments = ( alltrim(cursor1.comments) ? cursor1.comments : " " ) cursor1.close() //csql = "select id, email, alias where writeln("
") write(""+request.groupname+" league") writeln("
") writeln("") writeln("") writeln("") writeln("") write("
") write("Join League
") write("List Leagues
") write("Week "+cCurrweek+" Standings
") write("Cumulative Standings
") write("Home Page") writeln("		") csql = "select llogin, groupname from groupm where groupname = '" + request.groupname + "' and llogin = 'Y'" curstmp = database.cursor(csql) writeln("") if (curstmp.next()) { writeln("") getLogonTable() // if neccessary } else { writeln("You have no password on file!
Click here for more detils!") } curstmp.close() writeln("
") writeln("
") writeln("
") writeln("
") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("
League Name:"+request.groupname+"
Commissioner:"+commissioner+"
Description:"+description+"
Commissioner Comments:"+comments+"
") writeln("
") writeln("
") writeln("
") writeln("

") writeln("Below is list of players in this league.
") writeln("
") if (!database.connected()) { write("

Error: Database is not available.

") lContinue = false } if (lContinue) { cursor1 = database.cursor("select * from groupd where groupname = '" + request.groupname + "'") writeln("
") getPlayerTable(false) cursor1.close() if (nCt == 0) { writeln("
No players have joined this league yet.

") } lf = unescape("%0A") }